How to: Delete a header in a worksheet.
Solution:
Select 'Page Setup...' from the 'File' menu and choose 'Custom Header...' on the Header/Footer properties sheet.
1) Select the 'File' menu and select 'Page Setup...'. (The Page Setup dialog box appears.)
2) Click 'Header/Footer' tab.
3) Click 'Custom Header...'. (The Header dialog box appears.)
4) Select the desired header. (The header is highlighted.)
5) Press DELETE. (The Header dialog box reappears.)
6) Click 'OK' to close the 'Header' dialog box. (The Page Setup dialog box reappears.)
7) Click 'OK' to close the 'Page Setup' dialog box.